Profiling Report

Dataset statistics

Number of variables	17
Number of observations	2591730
Missing cells	12958650
Missing cells (%)	29.4%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	1.2 GiB
Average record size in memory	512.2 B

Variable types

Categorical	3
Text	4
Numeric	5
Unsupported	5

Alerts

`REF_DATE` has constant value ""	Constant
`Knowledge of official languages (5):Total - Knowledge of official languages[1]` is highly overall correlated with `Knowledge of official languages (5):English only[2]` and 2 other fields	High correlation
`Knowledge of official languages (5):English only[2]` is highly overall correlated with `Knowledge of official languages (5):Total - Knowledge of official languages[1]` and 2 other fields	High correlation
`Knowledge of official languages (5):French only[3]` is highly overall correlated with `Knowledge of official languages (5):English and French[4]`	High correlation
`Knowledge of official languages (5):English and French[4]` is highly overall correlated with `Knowledge of official languages (5):Total - Knowledge of official languages[1]` and 3 other fields	High correlation
`Knowledge of official languages (5):Neither English nor French[5]` is highly overall correlated with `Knowledge of official languages (5):Total - Knowledge of official languages[1]` and 2 other fields	High correlation
`Symbol` has 2591730 (100.0%) missing values	Missing
`Symbol.1` has 2591730 (100.0%) missing values	Missing
`Symbol.2` has 2591730 (100.0%) missing values	Missing
`Symbol.3` has 2591730 (100.0%) missing values	Missing
`Symbol.4` has 2591730 (100.0%) missing values	Missing
`Knowledge of official languages (5):Total - Knowledge of official languages[1]` is highly skewed (γ1 = 270.4104924)	Skewed
`Knowledge of official languages (5):English only[2]` is highly skewed (γ1 = 259.6271826)	Skewed
`Knowledge of official languages (5):French only[3]` is highly skewed (γ1 = 249.2697714)	Skewed
`Knowledge of official languages (5):English and French[4]` is highly skewed (γ1 = 235.2014829)	Skewed
`Knowledge of official languages (5):Neither English nor French[5]` is highly skewed (γ1 = 204.0238494)	Skewed
`Gender (3)` is uniformly distributed	Uniform
`Age (15A)` is uniformly distributed	Uniform
`Coordinate` has unique values	Unique
`Symbol` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`Symbol.1` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`Symbol.2` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`Symbol.3` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`Symbol.4` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`Knowledge of official languages (5):Total - Knowledge of official languages[1]` has 2090181 (80.6%) zeros	Zeros
`Knowledge of official languages (5):English only[2]` has 2157937 (83.3%) zeros	Zeros
`Knowledge of official languages (5):French only[3]` has 2513182 (97.0%) zeros	Zeros
`Knowledge of official languages (5):English and French[4]` has 2361395 (91.1%) zeros	Zeros
`Knowledge of official languages (5):Neither English nor French[5]` has 2451876 (94.6%) zeros	Zeros

Reproduction

Analysis started	2023-11-07 22:03:50.888406
Analysis finished	2023-11-07 22:04:48.274645
Duration	57.39 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

REF_DATE
Categorical

CONSTANT

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	150.8 MiB

2021	2591730

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Characters and Unicode

Total characters	10366920
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2021
2nd row	2021
3rd row	2021
4th row	2021
5th row	2021

Common Values

Value	Count	Frequency (%)
2021	2591730	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2021	2591730	100.0%

Most occurring characters

Value	Count	Frequency (%)
2	5183460	50.0%
0	2591730	25.0%
1	2591730	25.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	10366920	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	5183460	50.0%
0	2591730	25.0%
1	2591730	25.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	10366920	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	5183460	50.0%
0	2591730	25.0%
1	2591730	25.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	10366920	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	5183460	50.0%
0	2591730	25.0%
1	2591730	25.0%

GEO
Text

Distinct	174
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	198.2 MiB

Length

Max length	44
Median length	35
Mean length	21.827586
Min length	5

Characters and Unicode

Total characters	56571210
Distinct characters	58
Distinct categories	7 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Canada
2nd row	Canada
3rd row	Canada
4th row	Canada
5th row	Canada

Value	Count	Frequency (%)
ca	1742715	20.3%
ont	640485	7.5%
cma	640485	7.5%
que	476640	5.5%
b.c	417060	4.9%
alta	253215	2.9%
sask	148950	1.7%
part	119160	1.4%
	119160	1.4%
n.b	104265	1.2%
Other values (216)	3932280	45.8%

Most occurring characters

Value	Count	Frequency (%)
	6002685	10.6%
.	3276900	5.8%
C	3187530	5.6%
a	3142845	5.6%
e	3008790	5.3%
A	2785365	4.9%
t	2725785	4.8%
n	2636415	4.7%
(	2502360	4.4%
)	2502360	4.4%
Other values (48)	24800175	43.8%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	26989740	47.7%
Uppercase Letter	12422430	22.0%
Space Separator	6002685	10.6%
Other Punctuation	5749470	10.2%
Open Punctuation	2502360	4.4%
Close Punctuation	2502360	4.4%
Dash Punctuation	402165	0.7%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	3142845	11.6%
e	3008790	11.1%
t	2725785	10.1%
n	2636415	9.8%
r	2159775	8.0%
o	2040615	7.6%
i	1727820	6.4%
l	1608660	6.0%
u	1266075	4.7%
s	1161810	4.3%
Other values (16)	5511150	20.4%

Uppercase Letter

Value	Count	Frequency (%)
C	3187530	25.7%
A	2785365	22.4%
M	938385	7.6%
O	834120	6.7%
B	804330	6.5%
S	700065	5.6%
Q	625590	5.0%
N	476640	3.8%
L	268110	2.2%
P	253215	2.0%
Other values (14)	1549080	12.5%

Other Punctuation

Value	Count	Frequency (%)
.	3276900	57.0%
,	2383200	41.5%
/	59580	1.0%
'	29790	0.5%

Space Separator

Value	Count	Frequency (%)
	6002685	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	2502360	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	2502360	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	402165	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	39412170	69.7%
Common	17159040	30.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
C	3187530	8.1%
a	3142845	8.0%
e	3008790	7.6%
A	2785365	7.1%
t	2725785	6.9%
n	2636415	6.7%
r	2159775	5.5%
o	2040615	5.2%
i	1727820	4.4%
l	1608660	4.1%
Other values (40)	14388570	36.5%

Common

Value	Count	Frequency (%)
	6002685	35.0%
.	3276900	19.1%
(	2502360	14.6%
)	2502360	14.6%
,	2383200	13.9%
-	402165	2.3%
/	59580	0.3%
'	29790	0.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	56496735	99.9%
None	74475	0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	6002685	10.6%
.	3276900	5.8%
C	3187530	5.6%
a	3142845	5.6%
e	3008790	5.3%
A	2785365	4.9%
t	2725785	4.8%
n	2636415	4.7%
(	2502360	4.4%
)	2502360	4.4%
Other values (45)	24725700	43.8%

None

Value	Count	Frequency (%)
é	29790	40.0%
è	29790	40.0%
Î	14895	20.0%

DGUID
Text

Distinct	174
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	170.6 MiB

Length

Max length	14
Median length	12
Mean length	12.028736
Min length	11

Characters and Unicode

Total characters	31175235
Distinct characters	12
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2021A000011124
2nd row	2021A000011124
3rd row	2021A000011124
4th row	2021A000011124
5th row	2021A000011124

Value	Count	Frequency (%)
2021a000011124	14895	0.6%
2021a000212	14895	0.6%
2021s0504225	14895	0.6%
2021s0504015	14895	0.6%
2021s0504011	14895	0.6%
2021s0504010	14895	0.6%
2021s0503001	14895	0.6%
2021a000211	14895	0.6%
2021s0504105	14895	0.6%
2021s0504110	14895	0.6%
Other values (164)	2442780	94.3%

Most occurring characters

Value	Count	Frequency (%)
0	9026370	29.0%
2	6121845	19.6%
5	3976965	12.8%
1	3262005	10.5%
4	2591730	8.3%
S	2383200	7.6%
3	1429920	4.6%
9	625590	2.0%
6	595800	1.9%
8	551115	1.8%
Other values (2)	610695	2.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	28583505	91.7%
Uppercase Letter	2591730	8.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	9026370	31.6%
2	6121845	21.4%
5	3976965	13.9%
1	3262005	11.4%
4	2591730	9.1%
3	1429920	5.0%
9	625590	2.2%
6	595800	2.1%
8	551115	1.9%
7	402165	1.4%

Uppercase Letter

Value	Count	Frequency (%)
S	2383200	92.0%
A	208530	8.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	28583505	91.7%
Latin	2591730	8.3%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	9026370	31.6%
2	6121845	21.4%
5	3976965	13.9%
1	3262005	11.4%
4	2591730	9.1%
3	1429920	5.0%
9	625590	2.2%
6	595800	2.1%
8	551115	1.9%
7	402165	1.4%

Latin

Value	Count	Frequency (%)
S	2383200	92.0%
A	208530	8.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	31175235	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	9026370	29.0%
2	6121845	19.6%
5	3976965	12.8%
1	3262005	10.5%
4	2591730	8.3%
S	2383200	7.6%
3	1429920	4.6%
9	625590	2.0%
6	595800	1.9%
8	551115	1.8%
Other values (2)	610695	2.0%

Gender (3)
Categorical

UNIFORM

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	160.7 MiB

Total - Gender	863910
Men+	863910
Women+	863910

Length

Max length	14
Median length	6
Mean length	8
Min length	4

Characters and Unicode

Total characters	20733840
Distinct characters	16
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Total - Gender
2nd row	Total - Gender
3rd row	Total - Gender
4th row	Total - Gender
5th row	Total - Gender

Common Values

Value	Count	Frequency (%)
Total - Gender	863910	33.3%
Men+	863910	33.3%
Women+	863910	33.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
total	863910	20.0%
	863910	20.0%
gender	863910	20.0%
men	863910	20.0%
women	863910	20.0%

Most occurring characters

Value	Count	Frequency (%)
e	3455640	16.7%
n	2591730	12.5%
o	1727820	8.3%
	1727820	8.3%
+	1727820	8.3%
T	863910	4.2%
t	863910	4.2%
a	863910	4.2%
l	863910	4.2%
-	863910	4.2%
Other values (6)	5183460	25.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	12958650	62.5%
Uppercase Letter	3455640	16.7%
Space Separator	1727820	8.3%
Math Symbol	1727820	8.3%
Dash Punctuation	863910	4.2%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	3455640	26.7%
n	2591730	20.0%
o	1727820	13.3%
t	863910	6.7%
a	863910	6.7%
l	863910	6.7%
d	863910	6.7%
r	863910	6.7%
m	863910	6.7%

Uppercase Letter

Value	Count	Frequency (%)
T	863910	25.0%
G	863910	25.0%
M	863910	25.0%
W	863910	25.0%

Space Separator

Value	Count	Frequency (%)
	1727820	100.0%

Math Symbol

Value	Count	Frequency (%)
+	1727820	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	863910	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	16414290	79.2%
Common	4319550	20.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	3455640	21.1%
n	2591730	15.8%
o	1727820	10.5%
T	863910	5.3%
t	863910	5.3%
a	863910	5.3%
l	863910	5.3%
G	863910	5.3%
d	863910	5.3%
r	863910	5.3%
Other values (3)	2591730	15.8%

Common

Value	Count	Frequency (%)
	1727820	40.0%
+	1727820	40.0%
-	863910	20.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	20733840	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	3455640	16.7%
n	2591730	12.5%
o	1727820	8.3%
	1727820	8.3%
+	1727820	8.3%
T	863910	4.2%
t	863910	4.2%
a	863910	4.2%
l	863910	4.2%
-	863910	4.2%
Other values (6)	5183460	25.0%

Age (15A)
Categorical

UNIFORM

Distinct	15
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	174.7 MiB

Total - Age	172782
0 to 14 years	172782
0 to 4 years	172782
5 to 9 years	172782
10 to 14 years	172782
Other values (10)	1727820

Length

Max length	17
Median length	14
Mean length	13.666667
Min length	11

Characters and Unicode

Total characters	35420310
Distinct characters	25
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Total - Age
2nd row	Total - Age
3rd row	Total - Age
4th row	Total - Age
5th row	Total - Age

Common Values

Value	Count	Frequency (%)
Total - Age	172782	6.7%
0 to 14 years	172782	6.7%
0 to 4 years	172782	6.7%
5 to 9 years	172782	6.7%
10 to 14 years	172782	6.7%
15 to 24 years	172782	6.7%
15 to 19 years	172782	6.7%
20 to 24 years	172782	6.7%
25 to 64 years	172782	6.7%
25 to 34 years	172782	6.7%
Other values (5)	863910	33.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
years	2418948	23.7%
to	2246166	22.0%
15	345564	3.4%
64	345564	3.4%
0	345564	3.4%
14	345564	3.4%
25	345564	3.4%
24	345564	3.4%
total	172782	1.7%
45	172782	1.7%
Other values (18)	3110076	30.5%

Most occurring characters

Value	Count	Frequency (%)
	7602408	21.5%
e	2764512	7.8%
a	2764512	7.8%
o	2591730	7.3%
r	2591730	7.3%
t	2418948	6.8%
s	2418948	6.8%
y	2418948	6.8%
4	2246166	6.3%
5	2073384	5.9%
Other values (15)	5529024	15.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	18833238	53.2%
Decimal Number	8466318	23.9%
Space Separator	7602408	21.5%
Uppercase Letter	345564	1.0%
Dash Punctuation	172782	0.5%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	2764512	14.7%
a	2764512	14.7%
o	2591730	13.8%
r	2591730	13.8%
t	2418948	12.8%
s	2418948	12.8%
y	2418948	12.8%
n	172782	0.9%
d	172782	0.9%
g	172782	0.9%
Other values (2)	345564	1.8%

Decimal Number

Value	Count	Frequency (%)
4	2246166	26.5%
5	2073384	24.5%
1	1036692	12.2%
2	863910	10.2%
0	691128	8.2%
6	518346	6.1%
3	345564	4.1%
7	345564	4.1%
9	345564	4.1%

Uppercase Letter

Value	Count	Frequency (%)
T	172782	50.0%
A	172782	50.0%

Space Separator

Value	Count	Frequency (%)
	7602408	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	172782	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	19178802	54.1%
Common	16241508	45.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	2764512	14.4%
a	2764512	14.4%
o	2591730	13.5%
r	2591730	13.5%
t	2418948	12.6%
s	2418948	12.6%
y	2418948	12.6%
n	172782	0.9%
d	172782	0.9%
T	172782	0.9%
Other values (4)	691128	3.6%

Common

Value	Count	Frequency (%)
	7602408	46.8%
4	2246166	13.8%
5	2073384	12.8%
1	1036692	6.4%
2	863910	5.3%
0	691128	4.3%
6	518346	3.2%
3	345564	2.1%
7	345564	2.1%
9	345564	2.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	35420310	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	7602408	21.5%
e	2764512	7.8%
a	2764512	7.8%
o	2591730	7.3%
r	2591730	7.3%
t	2418948	6.8%
s	2418948	6.8%
y	2418948	6.8%
4	2246166	6.3%
5	2073384	5.9%
Other values (15)	5529024	15.6%

Mother tongue (331)
Text

Distinct	331
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	177.6 MiB

Length

Max length	46
Median length	30
Mean length	14.661631
Min length	2

Characters and Unicode

Total characters	37998990
Distinct characters	61
Distinct categories	7 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Total - Mother tongue
2nd row	Single responses
3rd row	Official languages
4th row	English
5th row	French

Value	Count	Frequency (%)
languages	743850	16.1%
n.i.e	266220	5.8%
n.o.s	117450	2.5%
cree	62640	1.4%
german	39150	0.8%
english	39150	0.8%
creole	39150	0.8%
non-official	39150	0.8%
sign	31320	0.7%
tutchone	31320	0.7%
Other values (340)	3210300	69.5%

Most occurring characters

Value	Count	Frequency (%)
a	4838940	12.7%
n	3734910	9.8%
i	2826630	7.4%
e	2795310	7.4%
	2027970	5.3%
g	2027970	5.3%
s	1855710	4.9%
l	1714770	4.5%
u	1675620	4.4%
o	1464210	3.9%
Other values (51)	13036950	34.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	29479950	77.6%
Uppercase Letter	3664440	9.6%
Space Separator	2027970	5.3%
Other Punctuation	1659960	4.4%
Close Punctuation	399330	1.1%
Open Punctuation	399330	1.1%
Dash Punctuation	368010	1.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	4838940	16.4%
n	3734910	12.7%
i	2826630	9.6%
e	2795310	9.5%
g	2027970	6.9%
s	1855710	6.3%
l	1714770	5.8%
u	1675620	5.7%
o	1464210	5.0%
r	1166670	4.0%
Other values (18)	5379210	18.2%

Uppercase Letter

Value	Count	Frequency (%)
S	469800	12.8%
C	321030	8.8%
I	305370	8.3%
A	297540	8.1%
T	289710	7.9%
K	211410	5.8%
N	203580	5.6%
M	203580	5.6%
B	148770	4.1%
P	148770	4.1%
Other values (16)	1064880	29.1%

Other Punctuation

Value	Count	Frequency (%)
.	1143180	68.9%
,	446310	26.9%
'	70470	4.2%

Space Separator

Value	Count	Frequency (%)
	2027970	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	399330	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	399330	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	368010	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	33144390	87.2%
Common	4854600	12.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	4838940	14.6%
n	3734910	11.3%
i	2826630	8.5%
e	2795310	8.4%
g	2027970	6.1%
s	1855710	5.6%
l	1714770	5.2%
u	1675620	5.1%
o	1464210	4.4%
r	1166670	3.5%
Other values (44)	9043650	27.3%

Common

Value	Count	Frequency (%)
	2027970	41.8%
.	1143180	23.5%
,	446310	9.2%
)	399330	8.2%
(	399330	8.2%
-	368010	7.6%
'	70470	1.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	37967670	99.9%
None	31320	0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	4838940	12.7%
n	3734910	9.8%
i	2826630	7.4%
e	2795310	7.4%
	2027970	5.3%
g	2027970	5.3%
s	1855710	4.9%
l	1714770	4.5%
u	1675620	4.4%
o	1464210	3.9%
Other values (48)	13005630	34.3%

None

Value	Count	Frequency (%)
é	15660	50.0%
É	7830	25.0%
ò	7830	25.0%

Coordinate
Text

UNIQUE

Distinct	2591730
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	166.7 MiB

Length

Max length	12
Median length	11
Mean length	10.453026
Min length	7

Characters and Unicode

Total characters	27091422
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2591730 ?
Unique (%)	100.0%

Sample

1st row	1.1.1.1
2nd row	1.1.1.2
3rd row	1.1.1.3
4th row	1.1.1.4
5th row	1.1.1.5

Value	Count	Frequency (%)
1.1.1.1	1	< 0.1%
1.1.1.6	1	< 0.1%
1.1.1.22	1	< 0.1%
1.1.1.20	1	< 0.1%
1.1.1.78	1	< 0.1%
1.1.1.10	1	< 0.1%
1.1.1.3	1	< 0.1%
1.1.1.4	1	< 0.1%
1.1.1.5	1	< 0.1%
1.1.1.7	1	< 0.1%
Other values (2591720)	2591720	> 99.9%

Most occurring characters

Value	Count	Frequency (%)
.	7775190	28.7%
1	5291721	19.5%
2	3130074	11.6%
3	2534994	9.4%
4	1404864	5.2%
5	1389969	5.1%
6	1217187	4.5%
7	1142712	4.2%
8	1068237	3.9%
9	1068237	3.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	19316232	71.3%
Other Punctuation	7775190	28.7%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	5291721	27.4%
2	3130074	16.2%
3	2534994	13.1%
4	1404864	7.3%
5	1389969	7.2%
6	1217187	6.3%
7	1142712	5.9%
8	1068237	5.5%
9	1068237	5.5%
0	1068237	5.5%

Other Punctuation

Value	Count	Frequency (%)
.	7775190	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	27091422	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
.	7775190	28.7%
1	5291721	19.5%
2	3130074	11.6%
3	2534994	9.4%
4	1404864	5.2%
5	1389969	5.1%
6	1217187	4.5%
7	1142712	4.2%
8	1068237	3.9%
9	1068237	3.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	27091422	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
.	7775190	28.7%
1	5291721	19.5%
2	3130074	11.6%
3	2534994	9.4%
4	1404864	5.2%
5	1389969	5.1%
6	1217187	4.5%
7	1142712	4.2%
8	1068237	3.9%
9	1068237	3.9%

Knowledge of official languages (5):Total - Knowledge of official languages[1]
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	12698
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1067.7934

Minimum	0
Maximum	36620955
Zeros	2090181
Zeros (%)	80.6%
Negative	0
Negative (%)	0.0%
Memory size	19.8 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	145
Maximum	36620955
Range	36620955
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	65127.087
Coefficient of variation (CV)	60.992215
Kurtosis	108736.73
Mean	1067.7934
Median Absolute Deviation (MAD)	0
Skewness	270.41049
Sum	2.7674323 × 10⁹
Variance	4.2415375 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2090181	80.6%
5	138734	5.4%
10	56122	2.2%
15	32646	1.3%
20	22668	0.9%
25	17008	0.7%
30	13478	0.5%
35	10818	0.4%
40	8975	0.3%
45	7717	0.3%
Other values (12688)	193383	7.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2090181	80.6%
5	138734	5.4%
10	56122	2.2%
15	32646	1.3%
20	22668	0.9%
25	17008	0.7%
30	13478	0.5%
35	10818	0.4%
40	8975	0.3%
45	7717	0.3%

Value	Count	Frequency (%)
36620955	1	< 0.1%
35145265	1	< 0.1%
27296445	1	< 0.1%
20107200	1	< 0.1%
19646805	1	< 0.1%
18866595	1	< 0.1%
18557080	1	< 0.1%
18063870	1	< 0.1%
17800600	1	< 0.1%
17344660	1	< 0.1%

Symbol
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	2591730
Missing (%)	100.0%
Memory size	19.8 MiB

Knowledge of official languages (5):English only[2]
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	10817
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	749.97096

Minimum	0
Maximum	25261655
Zeros	2157937
Zeros (%)	83.3%
Negative	0
Negative (%)	0.0%
Memory size	19.8 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	85
Maximum	25261655
Range	25261655
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	47375.916
Coefficient of variation (CV)	63.170333
Kurtosis	97219.603
Mean	749.97096
Median Absolute Deviation (MAD)	0
Skewness	259.62718
Sum	1.9437222 × 10⁹
Variance	2.2444774 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2157937	83.3%
5	124602	4.8%
10	49527	1.9%
15	28415	1.1%
20	19617	0.8%
25	14728	0.6%
30	11541	0.4%
35	9212	0.4%
40	7737	0.3%
45	6681	0.3%
Other values (10807)	161733	6.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2157937	83.3%
5	124602	4.8%
10	49527	1.9%
15	28415	1.1%
20	19617	0.8%
25	14728	0.6%
30	11541	0.4%
35	9212	0.4%
40	7737	0.3%
45	6681	0.3%

Value	Count	Frequency (%)
25261655	1	< 0.1%
24306165	1	< 0.1%
18325325	1	< 0.1%
18285580	1	< 0.1%
13787630	1	< 0.1%
13248710	1	< 0.1%
12640800	1	< 0.1%
12620855	1	< 0.1%
12196575	1	< 0.1%
12154280	1	< 0.1%

Symbol.1
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	2591730
Missing (%)	100.0%
Memory size	19.8 MiB

Knowledge of official languages (5):French only[3]
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	3255
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	101.06102

Minimum	0
Maximum	4087895
Zeros	2513182
Zeros (%)	97.0%
Negative	0
Negative (%)	0.0%
Memory size	19.8 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	4087895
Range	4087895
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	10027.686
Coefficient of variation (CV)	99.224074
Kurtosis	79968.312
Mean	101.06102
Median Absolute Deviation (MAD)	0
Skewness	249.26977
Sum	2.6192287 × 10⁸
Variance	1.0055448 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2513182	97.0%
5	27848	1.1%
10	9482	0.4%
15	5053	0.2%
20	3340	0.1%
25	2419	0.1%
30	1964	0.1%
35	1538	0.1%
40	1223	< 0.1%
45	1059	< 0.1%
Other values (3245)	24622	1.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2513182	97.0%
5	27848	1.1%
10	9482	0.4%
15	5053	0.2%
20	3340	0.1%
25	2419	0.1%
30	1964	0.1%
35	1538	0.1%
40	1223	< 0.1%
45	1059	< 0.1%

Value	Count	Frequency (%)
4087895	1	< 0.1%
4029960	1	< 0.1%
3980275	1	< 0.1%
3925600	1	< 0.1%
3734010	1	< 0.1%
3728020	1	< 0.1%
3638955	1	< 0.1%
3633980	1	< 0.1%
2173390	1	< 0.1%
2142665	1	< 0.1%

Symbol.2
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	2591730
Missing (%)	100.0%
Memory size	19.8 MiB

Knowledge of official languages (5):English and French[4]
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	5473
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	188.13551

Minimum	0
Maximum	6581680
Zeros	2361395
Zeros (%)	91.1%
Negative	0
Negative (%)	0.0%
Memory size	19.8 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	10
Maximum	6581680
Range	6581680
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	13140.444
Coefficient of variation (CV)	69.845635
Kurtosis	78425.758
Mean	188.13551
Median Absolute Deviation (MAD)	0
Skewness	235.20148
Sum	4.8759644 × 10⁸
Variance	1.7267127 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2361395	91.1%
5	74834	2.9%
10	26072	1.0%
15	14684	0.6%
20	10096	0.4%
25	7504	0.3%
30	5904	0.2%
35	4752	0.2%
40	3829	0.1%
45	3483	0.1%
Other values (5463)	79177	3.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2361395	91.1%
5	74834	2.9%
10	26072	1.0%
15	14684	0.6%
20	10096	0.4%
25	7504	0.3%
30	5904	0.2%
35	4752	0.2%
40	3829	0.1%
45	3483	0.1%

Value	Count	Frequency (%)
6581680	1	< 0.1%
6130560	1	< 0.1%
5226490	1	< 0.1%
3898980	1	< 0.1%
3766750	1	< 0.1%
3675005	1	< 0.1%
3554305	1	< 0.1%
3419880	1	< 0.1%
3337330	1	< 0.1%
3244350	1	< 0.1%

Symbol.3
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	2591730
Missing (%)	100.0%
Memory size	19.8 MiB

Knowledge of official languages (5):Neither English nor French[5]
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	2600
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	28.55237

Minimum	0
Maximum	689725
Zeros	2451876
Zeros (%)	94.6%
Negative	0
Negative (%)	0.0%
Memory size	19.8 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	5
Maximum	689725
Range	689725
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1603.2533
Coefficient of variation (CV)	56.151322
Kurtosis	63647.582
Mean	28.55237
Median Absolute Deviation (MAD)	0
Skewness	204.02385
Sum	74000035
Variance	2570421.3
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2451876	94.6%
5	52148	2.0%
10	18248	0.7%
15	9934	0.4%
20	6899	0.3%
25	4881	0.2%
30	3806	0.1%
35	2944	0.1%
40	2503	0.1%
45	2052	0.1%
Other values (2590)	36439	1.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2451876	94.6%
5	52148	2.0%
10	18248	0.7%
15	9934	0.4%
20	6899	0.3%
25	4881	0.2%
30	3806	0.1%
35	2944	0.1%
40	2503	0.1%
45	2052	0.1%

Value	Count	Frequency (%)
689725	1	< 0.1%
678580	1	< 0.1%
667955	1	< 0.1%
662420	1	< 0.1%
405555	1	< 0.1%
399290	1	< 0.1%
394210	1	< 0.1%
391515	1	< 0.1%
344545	1	< 0.1%
339275	1	< 0.1%

Symbol.4
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	2591730
Missing (%)	100.0%
Memory size	19.8 MiB

Auto

Heatmap
Table

	Knowledge of official languages (5):Total - Knowledge of official languages[1]	Knowledge of official languages (5):English only[2]	Knowledge of official languages (5):French only[3]	Knowledge of official languages (5):English and French[4]	Knowledge of official languages (5):Neither English nor French[5]	Gender (3)	Age (15A)
Knowledge of official languages (5):Total - Knowledge of official languages[1]	1.000	0.924	0.398	0.690	0.543	0.002	0.005
Knowledge of official languages (5):English only[2]	0.924	1.000	0.268	0.597	0.536	0.002	0.005
Knowledge of official languages (5):French only[3]	0.398	0.268	1.000	0.525	0.409	0.003	0.005
Knowledge of official languages (5):English and French[4]	0.690	0.597	0.525	1.000	0.542	0.001	0.005
Knowledge of official languages (5):Neither English nor French[5]	0.543	0.536	0.409	0.542	1.000	0.004	0.007
Gender (3)	0.002	0.002	0.003	0.001	0.004	1.000	0.000
Age (15A)	0.005	0.005	0.005	0.005	0.007	0.000	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	REF_DATE	GEO	DGUID	Gender (3)	Age (15A)	Mother tongue (331)	Coordinate	Knowledge of official languages (5):Total - Knowledge of official languages[1]	Symbol	Knowledge of official languages (5):English only[2]	Symbol.1	Knowledge of official languages (5):French only[3]	Symbol.2	Knowledge of official languages (5):English and French[4]	Symbol.3	Knowledge of official languages (5):Neither English nor French[5]	Symbol.4
0	2021	Canada	2021A000011124	Total - Gender	Total - Age	Total - Mother tongue	1.1.1.1	36620955	NaN	25261655	NaN	4087895	NaN	6581680	NaN	689725	NaN
1	2021	Canada	2021A000011124	Total - Gender	Total - Age	Single responses	1.1.1.2	35145265	NaN	24306165	NaN	4029960	NaN	6130560	NaN	678580	NaN
2	2021	Canada	2021A000011124	Total - Gender	Total - Age	Official languages	1.1.1.3	27296445	NaN	18325325	NaN	3734010	NaN	5226490	NaN	10620	NaN
3	2021	Canada	2021A000011124	Total - Gender	Total - Age	English	1.1.1.4	20107200	NaN	18285580	NaN	5990	NaN	1806605	NaN	9025	NaN
4	2021	Canada	2021A000011124	Total - Gender	Total - Age	French	1.1.1.5	7189245	NaN	39740	NaN	3728020	NaN	3419880	NaN	1595	NaN
5	2021	Canada	2021A000011124	Total - Gender	Total - Age	Non-official languages	1.1.1.6	7848820	NaN	5980845	NaN	295950	NaN	904065	NaN	667955	NaN
6	2021	Canada	2021A000011124	Total - Gender	Total - Age	Indigenous languages	1.1.1.7	148895	NaN	123580	NaN	10995	NaN	8785	NaN	5535	NaN
7	2021	Canada	2021A000011124	Total - Gender	Total - Age	Algonquian languages	1.1.1.8	97125	NaN	79020	NaN	10730	NaN	5625	NaN	1760	NaN
8	2021	Canada	2021A000011124	Total - Gender	Total - Age	Blackfoot	1.1.1.9	2520	NaN	2480	NaN	0	NaN	25	NaN	10	NaN
9	2021	Canada	2021A000011124	Total - Gender	Total - Age	Cree-Innu languages	1.1.1.10	67665	NaN	51030	NaN	10405	NaN	4780	NaN	1455	NaN

	REF_DATE	GEO	DGUID	Gender (3)	Age (15A)	Mother tongue (331)	Coordinate	Knowledge of official languages (5):Total - Knowledge of official languages[1]	Symbol	Knowledge of official languages (5):English only[2]	Symbol.1	Symbol.2	Symbol.3	Symbol.4
2591720	2021	Nunavut	2021A000262	Women+	75 years and over	Estonian	174.3.15.322	0	NaN	0	NaN	NaN	NaN	NaN
2591721	2021	Nunavut	2021A000262	Women+	75 years and over	Finnish	174.3.15.323	0	NaN	0	NaN	NaN	NaN	NaN
2591722	2021	Nunavut	2021A000262	Women+	75 years and over	Hungarian	174.3.15.324	0	NaN	0	NaN	NaN	NaN	NaN
2591723	2021	Nunavut	2021A000262	Women+	75 years and over	Other languages, n.i.e.	174.3.15.325	0	NaN	0	NaN	NaN	NaN	NaN
2591724	2021	Nunavut	2021A000262	Women+	75 years and over	Multiple responses	174.3.15.326	15	NaN	15	NaN	NaN	NaN	NaN
2591725	2021	Nunavut	2021A000262	Women+	75 years and over	English and French	174.3.15.327	0	NaN	0	NaN	NaN	NaN	NaN
2591726	2021	Nunavut	2021A000262	Women+	75 years and over	English and non-official language(s)	174.3.15.328	15	NaN	15	NaN	NaN	NaN	NaN
2591727	2021	Nunavut	2021A000262	Women+	75 years and over	French and non-official language(s)	174.3.15.329	0	NaN	0	NaN	NaN	NaN	NaN
2591728	2021	Nunavut	2021A000262	Women+	75 years and over	English, French and non-official language(s)	174.3.15.330	0	NaN	0	NaN	NaN	NaN	NaN
2591729	2021	Nunavut	2021A000262	Women+	75 years and over	Multiple non-official languages	174.3.15.331	0	NaN	0	NaN	NaN	NaN	NaN

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Other Punctuation

Space Separator

Open Punctuation

Close Punctuation

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

None

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Uppercase Letter

Most occurring scripts

Most frequent character per script

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Math Symbol

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Decimal Number

Uppercase Letter

Space Separator

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII